| webItems |
| Logical Entity Name | webItems |
| Default Table Name | webItems |
| Physical Only | NO |
| Definition | |
| Note |
| webItems Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
webItemsID |
int | NO | ||
| item | varchar(50) | YES | ||
| event | varchar(50) | YES | ||
| access | varchar(50) | YES | ||
| accessDescrip | varchar(50) | YES | ||
| enabled | bit | NO | ||
| descrip | varchar(100) | YES | ||
| pageDescrip | varchar(100) | YES | ||
| syStaffID | int | YES | ||
| pageKeywords | varchar(255) | YES | ||
| dateLastMod | datetime | YES | ||
| dateLastUpdate | datetime | YES | ||
| userID | int | YES | ||
| ts | timestamp | NO |
| webItems Primary and Unique Keys |
| Key Name | Key Type | Keys |
| webItems_webItemsID_U_C_IDX | PrimaryKey | webItemsID |
| webItems Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| webItems Check Constraints |
| Check Constraint Name | CheckConstraint |